Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_2439

R_2439

PhResourceType

PhLResourceTypeSt

ResourceTypeID

 

 

R_2440

R_2440

PhSt

PhLResourceTypeSt

StID

 

 

R_2441

R_2441

PhTimePeriod

PhTenderOfferItem

ValidityPeriodUnitID

 

 

R_2442

R_2442

PhStDocItem

PhStPlaceMovementItem

StDocItemID

 

 

R_2443

R_2443

PhReturnToDelStatus

PhReturnToDelStatusText

ReturnToDelStatusID

 

 

R_2444

R_2444

PhReturnToDelKind

PhReturnToDelKindText

ReturnToDelKindID

 

 

R_2445

R_2445

PhReturnToDelItemReason

PhReturnToDelItemReasonText

ReturnToDelItemReasonID

 

 

R_2446

R_2446

PhReturnToDelStatus

PhReturnToDel

ReturnToDelStatusID

 

 

R_2447

R_2447

PhReturnToDelKind

PhReturnToDel

ReturnToDelKindID

 

 

R_2448

R_2448

PhReturnToDelItemReason

PhReturnToDelItem

ReturnToDelItemReasonID

 

 

R_2449

R_2449

PhCompany

PhReturnToDel

DelivererID

 

 

R_2450

R_2450

PhTradeDoc

PhReturnToDel

TradeDocID

 

 

R_2451

R_2451

PhReturnToDel

PhReturnToDelItem

ReturnToDelID

 

 

R_2452

R_2452

PhLot

PhReturnToDelItem

LotID

 

 

R_2453

R_2453

PhStItem

PhReturnToDelItem

StItemID

 

 

R_2454

R_2454

PhSt

PhStForProduction

StID

 

 

R_2455

R_2455

PhTradeDoc

PhReturnToDel

CorrectingTradeDocID

 

 

R_2456

R_2456

PhStDoc

PhReturnToDel

StDocID

 

 

R_2457

R_2457

PhStOrderItem

PhDrugProd

StOrderItemID

 

 

R_2458

R_2458

PhSt

PhOrderToDeliverer

StID

 

 

R_2459

R_2459

PhSt

PhTradeDoc

StID

 

 

R_2460

R_2460

PhTenderOfferItem

PhOrderRealization

TenderOfferItemID

 

 

R_2461

R_2461

Person

PhDrugProd

PersonID

 

 

R_2462

R_2462

PhSt

PhDrugProd

StID

 

 

R_2463

R_2463

PhSt

PhDrugProd

StoragePlaceID

 

 

R_2464

R_2464

PhDrugProdStatus

PhDrugProd

DrugProdStatusID

 

 

R_2465

R_2465

PhDrugProdStatus

PhDrugProdStatusText

DrugProdStatusID

 

 

R_2466

R_2466

PhDrugAppMethodType

PhDrugAppMethodTypeText

DrugAppMethodTypeID

 

 

R_2467

R_2467

PhDrugAppPlaceType

PhDrugAppPlaceTypeText

DrugAppPlaceTypeID

 

 

R_2468

R_2468

PhDrugAppMethodType

PhDrugProd

DrugAppMethodTypeID

 

 

R_2469

R_2469

PhDrugAppPlaceType

PhDrugProd

DrugAppPlaceTypeID

 

 

R_2470

R_2470

PhBlockadeLot

PhLBlockadeLotLot

BlockadeLotID

 

 

R_2471

R_2471

PhLot

PhLBlockadeLotLot

LotID

 

 

R_2472

R_2472

PhStItem

PhLimit

StItemID

 

 

R_2473

R_2473

PhTreatmentResult

PhTreatmentResultText

TreatmentResultID

 

 

R_2474

R_2474

PhStAccessType

PhStAccessTypeText

StAccessTypeID

 

 

R_2475

R_2475

PhSt

PhLStUserDefinition

StID

 

 

R_2476

R_2476

PhStAccessType

PhLStUserDefinition

StAccessTypeID

 

 

R_2477

R_2477

REVINFO

PhStDocStDocItemHist

rev

 

 

R_2480

R_2480

REVINFO

PhStDocHist

REV

 

 

R_2481

R_2481

REVINFO

PhStDocItemHist

REV

 

 

R_2482

R_2482

PhDrugAlias

PhLDrugAliasAppWay

DrugAliasID

 

 

R_2483

R_2483

ApplicationWay

PhLDrugAliasAppWay

ApplicationWayID

 

 

R_2484

R_2484

PhLotInSt

PhLPerfResourceProdIngr

IngrLotInStID

 

 

R_2485

R_2485

PhLotInSt

PhLPerfResourceProdIngr

ProdLotInStID

 

 

R_2490

R_2490

CostAccount

PhSt

DefaultCostAccountID

 

 

R_2491

R_2491

PhUnit

PhInventoryItem

PresentationUnitID

 

 

R_2492

R_2492

PhFinancialSource

PhFinancialSourceText

FinancialSourceID

 

 

R_2493

R_2493

PhFinancialSource

PhLot

FinancialSourceID

 

 

R_2494

R_2494

PhFinancialSource

PhStDoc

FinancialSourceID

 

 


1  2  3  4  5  6  7  8